Excel IF函数如何跟AND和TODAY()一起用?答:将原公式作如下更改即可达到你想要的目的 =IF(D3<>"",IF(D3=C3,"未超期",IF(D3<C3,"如期","超期"&D3-C3&"天")),IF((TODAY()-C3)=0,"今天到期",IF((TODAY()-C3)>0,"已超期"&TODAY()-C3&"天","还差"&C3-TODAY()&"天到期")))示例如图:...
请教高手,excel中IF,FIND以及AND,OR嵌套问题!答:改成:=IF(AND(OR(ISNUMBER(FIND("US",AR3)),ISNUMBER(FIND("CA",AR3))),OR(ISNUMBER(FIND("CN",AR3)),ISNUMBER(FIND("JP",AR3)),ISNUMBER(FIND("KR",AR3)),ISNUMBER(FIND("TW",AR3))), OR(ISNUMBER(FIND("DE",AR3)),...